package net.huashitong.scheduling.dao;

import java.util.List;

import org.springframework.stereotype.Repository;

import com.sirdc.modules.core.dao.GenericQuery;
import com.sirdc.modules.core.dao.StringDao;

import net.huashitong.scheduling.entity.TownshipMotivate;
@Repository
public class TownshipMotivateDao extends StringDao<TownshipMotivate>{
     public List<TownshipMotivate> queryTownshipMotivateByDate(String currentMonth){
    	 GenericQuery query = createQuery("obj");
    	 query.append(" and obj.date =:date order by cast(obj.ranking as int) ASC ").setParam("date",currentMonth);
    	 return query.listResult();
     }
}
